MySQL Reference Manual for version 4.0.0-alpha.

• 1 General Information About MySQL
  • 1.1 MySQL, MySQL AB, and Open Source
    • 1.1.1 What Is MySQL
    • 1.1.2 What Is MySQL AB
      • 1.1.2.1 Contact Information
    • 1.1.3 About This Manual
    • 1.1.4 Conventions Used in This Manual
    • 1.1.5 History of MySQL
    • 1.1.6 The Main Features of MySQL
    • 1.1.7 How Stable Is MySQL?
    • 1.1.8 How Big Can MySQL Tables Be?
    • 1.1.9 Year 2000 Compliance
  • 1.2 MySQL Information Sources
    • 1.2.1 Books About MySQL
    • 1.2.2 General SQL Information and Tutorials
    • 1.2.3 Useful MySQL-related Links
    • 1.2.22 MySQL Mailing Lists
      • 1.2.22.1 The MySQL Mailing Lists
      • 1.2.22.2 Asking Questions or Reporting Bugs
      • 1.2.22.3 How to Report Bugs or Problems
      • 1.2.22.4 Guidelines for Answering Question on the Mailing List
  • 1.3 MySQL Support and Licensing
    • 1.3.1 Support offered by MySQL AB
    • 1.3.2 Copyrights Used by MySQL
      • 1.3.2.1 Copyright Changes
    • 1.3.3 MySQL Licensing Policy
    • 1.3.4 Example Licensing Situations
      • 1.3.4.1 Selling Products that use MySQL
      • 1.3.4.2 ISP MySQL Services
      • 1.3.4.3 Running a Web Server Using MySQL
  • 1.4 How Standards-compatible Is MySQL?
    • 1.4.1 MySQL Extensions to ANSI SQL92
    • 1.4.2 MySQL Differences Compared to ANSI SQL92
    • 1.4.3 Running MySQL in ANSI Mode
    • 1.4.4 Functionality Missing from MySQL
      • 1.4.4.1 Sub-selects
      • 1.4.4.2 SELECT INTO TABLE
      • 1.4.4.3 Transactions
      • 1.4.4.4 Stored Procedures and Triggers
      • 1.4.4.5 Foreign Keys
      • 1.4.4.6 Why We Did Not Implement Foreign Keys
      • 1.4.4.7 Views
      • 1.4.4.8 `--' as the Start of a Comment
    • 1.4.5 What Standards Does MySQL Follow?
    • 1.4.6 How to Cope Without COMMIT/ROLLBACK
    • 1.4.7 Known errors and design deficiencies in MySQL
  • 1.5 How MySQL Compares to Other Databases
    • 1.5.1 How MySQL Compares to mSQL
      • 1.5.1.1 How to Convert mSQL Tools for MySQL
      • 1.5.1.2 How mSQL and MySQL Client/Server Communications Protocols Differ
      • 1.5.1.3 How mSQL 2.0 SQL Syntax Differs from MySQL
    • 1.5.2 How MySQL Compares to PostgreSQL
      • 1.5.2.1 MySQL and PostgreSQL development strategies
      • 1.5.2.2 Featurewise Comparison of MySQL and PostgreSQL
      • 1.5.2.3 Benchmarking MySQL and PostgreSQL
  • 1.6 MySQL and the future (The TODO)
    • 1.6.1 Things that should be in 4.0
    • 1.6.2 Things that must be done in the real near future
    • 1.6.3 Things that have to be done sometime
    • 1.6.4 Some things we don't have any plans to do
• 2 MySQL Installation
  • 2.1 Quick Standard Installation of MySQL
    • 2.1.1 Installing MySQL on Linux
    • 2.1.2 Installing MySQL on Windows
  • 2.2 General Installation Issues
    • 2.2.1 How to Get MySQL
    • 2.2.2 Operating Systems Supported by MySQL
    • 2.2.3 Which MySQL Version to Use
    • 2.2.4 Installation Layouts
    • 2.2.5 How and When Updates Are Released
    • 2.2.6 MySQL Binaries Compiled by MySQL AB
  • 2.3 Installing a MySQL Source Distribution
    • 2.3.1 Quick Installation Overview
    • 2.3.2 Applying Patches
    • 2.3.3 Typical configure Options
    • 2.3.4 Installing from the Development Source Tree
    • 2.3.5 Problems Compiling?
    • 2.3.6 MIT-pthreads Notes
  • 2.4 Post-installation Setup and Testing
    • 2.4.1 Problems Running mysql_install_db
    • 2.4.2 Problems Starting the MySQL Server
    • 2.4.3 Starting and Stopping MySQL Automatically
  • 2.5 Upgrading/Downgrading MySQL
    • 2.5.1 Upgrading From Version 3.23 to Version 4.0
    • 2.5.2 Upgrading From Version 3.22 to Version 3.23
    • 2.5.3 Upgrading from Version 3.21 to Version 3.22
    • 2.5.4 Upgrading from Version 3.20 to Version 3.21
    • 2.5.5 Upgrading to Another Architecture
  • 2.6 Operating System Specific Notes
    • 2.6.1 Linux Notes (All Linux Versions)
      • 2.6.1.1 Linux Notes for Binary Distributions
      • 2.6.1.2 Linux x86 Notes
      • 2.6.1.3 Linux SPARC Notes
      • 2.6.1.4 Linux Alpha Notes
      • 2.6.1.5 Linux PowerPC Notes
      • 2.6.1.6 Linux MIPS Notes
      • 2.6.1.7 Linux IA64 Notes
    • 2.6.2 Windows Notes
      • 2.6.2.1 Starting MySQL on Windows 95 or Windows 98
      • 2.6.2.2 Starting MySQL on Windows NT or Windows 2000
      • 2.6.2.3 Running MySQL on Windows
      • 2.6.2.4 Connecting to a Remote MySQL from Windows with SSH
      • 2.6.2.5 Splitting Data Across Different Disks on Windows
      • 2.6.2.6 Compiling MySQL Clients on Windows
      • 2.6.2.7 MySQL-Windows Compared to Unix MySQL
    • 2.6.3 Solaris Notes
      • 2.6.3.1 Solaris 2.7/2.8 Notes
      • 2.6.3.2 Solaris x86 Notes
    • 2.6.4 BSD Notes
      • 2.6.4.1 FreeBSD Notes
      • 2.6.4.2 NetBSD notes
      • 2.6.4.3 OpenBSD Notes
      • 2.6.4.4 OpenBSD 2.5 Notes
      • 2.6.4.5 OpenBSD 2.8 Notes
      • 2.6.4.6 BSD/OS Notes
      • 2.6.4.7 BSD/OS Version 2.x Notes
      • 2.6.4.8 BSD/OS Version 3.x Notes
      • 2.6.4.9 BSD/OS Version 4.x Notes
    • 2.6.5 Mac OS X Notes
      • 2.6.5.1 Mac OS X Public Beta
      • 2.6.5.2 Mac OS X Server
    • 2.6.6 Other Unix Notes
      • 2.6.6.1 HP-UX Notes for Binary Distributions
      • 2.6.6.2 HP-UX Version 10.20 Notes
      • 2.6.6.3 HP-UX Version 11.x Notes
      • 2.6.6.4 IBM-AIX notes
      • 2.6.6.5 SunOS 4 Notes
      • 2.6.6.6 Alpha-DEC-UNIX Notes (Tru64)
      • 2.6.6.7 Alpha-DEC-OSF1 Notes
      • 2.6.6.8 SGI Irix Notes
      • 2.6.6.9 SCO Notes
      • 2.6.6.10 SCO Unixware Version 7.0 Notes
    • 2.6.7 OS/2 Notes
    • 2.6.8 BeOS Notes
    • 2.6.9 Novell Netware Notes
• 3 Introduction to MySQL: A MySQL Tutorial
  • 3.1 Connecting to and Disconnecting from the Server
  • 3.2 Entering Queries
  • 3.3 Creating and Using a Database
    • 3.3.1 Creating and Selecting a Database
    • 3.3.2 Creating a Table
    • 3.3.3 Loading Data into a Table
    • 3.3.4 Retrieving Information from a Table
      • 3.3.4.1 Selecting All Data
      • 3.3.4.2 Selecting Particular Rows
      • 3.3.4.3 Selecting Particular Columns
      • 3.3.4.4 Sorting Rows
      • 3.3.4.5 Date Calculations
      • 3.3.4.6 Working with NULL Values
      • 3.3.4.7 Pattern Matching
      • 3.3.4.8 Counting Rows
      • 3.3.4.9 Using More Than one Table
  • 3.4 Getting Information About Databases and Tables
  • 3.5 Examples of Common Queries
    • 3.5.1 The Maximum Value for a Column
    • 3.5.2 The Row Holding the Maximum of a Certain Column
    • 3.5.3 Maximum of Column per Group
    • 3.5.4 The Rows Holding the Group-wise Maximum of a Certain Field
    • 3.5.5 Using user variables
    • 3.5.6 Using Foreign Keys
    • 3.5.7 Searching on Two Keys
    • 3.5.8 Calculating visits per day
  • 3.6 Using mysql in Batch Mode
  • 3.7 Queries from Twin Project
    • 3.7.1 Find all Non-distributed Twins
    • 3.7.2 Show a Table on Twin Pair Status
  • 3.8 Using MySQL with Apache
• 4 MySQL Database Administration
  • 4.1 Configuring MySQL
    • 4.1.1 mysqld Command-line Options
    • 4.1.2 my.cnf Option Files
    • 4.1.3 Installing Many Servers on the Same Machine
    • 4.1.4 Running Multiple MySQL Servers on the Same Machine
  • 4.2 General Security Issues and the MySQL Access Privilege System
    • 4.2.1 General Security Guidelines
    • 4.2.2 How to Make MySQL Secure Against Crackers
    • 4.2.3 Startup Options for mysqld Concerning Security
    • 4.2.4 What the Privilege System Does
    • 4.2.5 How the Privilege System Works
    • 4.2.6 Privileges Provided by MySQL
    • 4.2.7 Connecting to the MySQL Server
    • 4.2.8 Access Control, Stage 1: Connection Verification
    • 4.2.9 Access Control, Stage 2: Request Verification
    • 4.2.10 Causes of Access denied Errors
  • 4.3 MySQL User Account Management
    • 4.3.1 GRANT and REVOKE Syntax
    • 4.3.2 MySQL User Names and Passwords
    • 4.3.3 When Privilege Changes Take Effect
    • 4.3.4 Setting Up the Initial MySQL Privileges
    • 4.3.5 Adding New Users to MySQL
    • 4.3.6 Setting Up Passwords
    • 4.3.7 Keeping Your Password Secure
    • 4.3.8 Using Secure Connections
      • 4.3.8.1 Basics
      • 4.3.8.2 Requirements
      • 4.3.8.3 GRANT options
  • 4.4 Disaster Prevention and Recovery
    • 4.4.1 Database Backups
    • 4.4.2 BACKUP TABLE Syntax
    • 4.4.3 RESTORE TABLE Syntax
    • 4.4.4 CHECK TABLE Syntax
    • 4.4.5 REPAIR TABLE Syntax
    • 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery
      • 4.4.6.1 myisamchk Invocation Syntax
      • 4.4.6.2 General Options for myisamchk
      • 4.4.6.3 Check Options for myisamchk
      • 4.4.6.4 Repair Options for myisamchk
      • 4.4.6.5 Other Options for myisamchk
      • 4.4.6.6 myisamchk Memory Usage
      • 4.4.6.7 Using myisamchk for Crash Recovery
      • 4.4.6.8 How to Check Tables for Errors
      • 4.4.6.9 How to Repair Tables
      • 4.4.6.10 Table Optimization
    • 4.4.7 Setting Up a Table Maintenance Regimen
    • 4.4.8 Getting Information About a Table
  • 4.5 Database Administration Language Reference
    • 4.5.1 OPTIMIZE TABLE Syntax
    • 4.5.2 ANALYZE TABLE Syntax
    • 4.5.3 FLUSH Syntax
    • 4.5.4 KILL Syntax
    • 4.5.5 SHOW Syntax
      • 4.5.5.1 Retrieving information about Database, Tables, Columns, and Indexes
      • 4.5.5.2 SHOW TABLE STATUS
      • 4.5.5.3 SHOW STATUS
      • 4.5.5.4 SHOW VARIABLES
      • 4.5.5.5 SHOW LOGS
      • 4.5.5.6 SHOW PROCESSLIST
      • 4.5.5.7 SHOW GRANTS
      • 4.5.5.8 SHOW CREATE TABLE
  • 4.6 MySQL Localization and International Usage
    • 4.6.1 The Character Set Used for Data and Sorting
      • 4.6.1.1 German character set
    • 4.6.2 Non-English Error Messages
    • 4.6.3 Adding a New Character Set
    • 4.6.4 The character definition arrays
    • 4.6.5 String Collating Support
    • 4.6.6 Multi-byte Character Support
    • 4.6.7 Problems With Character Sets
  • 4.7 MySQL Server-Side Scripts and Utilities
    • 4.7.1 Overview of the Server-Side Scripts and Utilities
    • 4.7.2 safe_mysqld, the wrapper around mysqld
    • 4.7.3 mysqld_multi, program for managing multiple MySQL servers
    • 4.7.4 myisampack, The MySQL Compressed Read-only Table Generator
    • 4.7.5 mysqld-max, An extended mysqld server
  • 4.8 MySQL Client-Side Scripts and Utilities
    • 4.8.1 Overview of the Client-Side Scripts and Utilities
    • 4.8.2 The Command-line Tool
    • 4.8.3 mysqladmin, Administrating a MySQL Server
    • 4.8.4 Using mysqlcheck for Table Maintenance and Crash Recovery
    • 4.8.5 mysqldump, Dumping Table Structure and Data
    • 4.8.6 mysqlhotcopy, Copying MySQL Databases and Tables
    • 4.8.7 mysqlimport, Importing Data from Text Files
    • 4.8.8 Showing Databases, Tables, and Columns
    • 4.8.9 perror, Explaining Error Codes
    • 4.8.10 How to Run SQL Commands from a Text File
  • 4.9 The MySQL Log Files
    • 4.9.1 The Error Log
    • 4.9.2 The General Query Log
    • 4.9.3 The Update Log
    • 4.9.4 The Binary Update Log
    • 4.9.5 The Slow Query Log
    • 4.9.6 Log File Maintenance
  • 4.10 Replication in MySQL
    • 4.10.1 Introduction
    • 4.10.2 Replication Implementation Overview
    • 4.10.3 How To Set Up Replication
    • 4.10.4 Replication Features and Known Problems
    • 4.10.5 Replication Options in my.cnf
    • 4.10.6 SQL Commands Related to Replication
    • 4.10.7 Replication FAQ
    • 4.10.8 Troubleshooting Replication
• 5 MySQL Optimization
  • 5.1 Optimization Overview
    • 5.1.1 MySQL Design Limitations/Tradeoffs
    • 5.1.2 Portability
    • 5.1.3 What Have We Used MySQL For?
    • 5.1.4 The MySQL Benchmark Suite
    • 5.1.5 Using Your Own Benchmarks
  • 5.2 Optimizing SELECTs and Other Queries
    • 5.2.1 EXPLAIN Syntax (Get Information About a SELECT)
    • 5.2.2 Estimating Query Performance
    • 5.2.3 Speed of SELECT Queries
    • 5.2.4 How MySQL Optimizes WHERE Clauses
    • 5.2.5 How MySQL Optimizes DISTINCT
    • 5.2.6 How MySQL Optimizes LEFT JOIN and RIGHT JOIN
    • 5.2.7 How MySQL Optimizes LIMIT
    • 5.2.8 Speed of INSERT Queries
    • 5.2.9 Speed of UPDATE Queries
    • 5.2.10 Speed of DELETE Queries
    • 5.2.11 Other Optimization Tips
  • 5.3 Locking Issues
    • 5.3.1 How MySQL Locks Tables
    • 5.3.2 Table Locking Issues
  • 5.4 Optimizing Database Structure
    • 5.4.1 Design Choices
    • 5.4.2 Get Your Data as Small as Possible
    • 5.4.3 How MySQL Uses Indexes
    • 5.4.4 Column Indexes
    • 5.4.5 Multiple-Column Indexes
    • 5.4.6 How MySQL Opens and Closes Tables
    • 5.4.7 Drawbacks to Creating Large Numbers of Tables in the Same Database
    • 5.4.8 Why So Many Open tables?
  • 5.5 Optimizing the MySQL Server
    • 5.5.1 System/Compile Time and Startup Parameter Tuning
    • 5.5.2 Tuning Server Parameters
    • 5.5.3 How Compiling and Linking Affects the Speed of MySQL
    • 5.5.4 How MySQL Uses Memory
    • 5.5.5 How MySQL uses DNS
    • 5.5.6 SET Syntax
  • 5.6 Disk Issues
    • 5.6.1 Using Symbolic Links
      • 5.6.1.1 Using Symbolic Links for Databases
      • 5.6.1.2 Using Symbolic Links for Tables
• 6 MySQL Language Reference
  • 6.1 Language Structure
    • 6.1.1 Literals: How to Write Strings and Numbers
      • 6.1.1.1 Strings
      • 6.1.1.2 Numbers
      • 6.1.1.3 Hexadecimal Values
      • 6.1.1.4 NULL Values
    • 6.1.2 Database, Table, Index, Column, and Alias Names
    • 6.1.3 Case Sensitivity in Names
    • 6.1.4 User Variables
    • 6.1.5 Comment Syntax
    • 6.1.6 Is MySQL Picky About Reserved Words?
  • 6.2 Column Types
    • 6.2.1 Numeric Types
    • 6.2.2 Date and Time Types
      • 6.2.2.1 Y2K Issues and Date Types
      • 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
      • 6.2.2.3 The TIME Type
      • 6.2.2.4 The YEAR Type
    • 6.2.3 String Types
      • 6.2.3.1 The CHAR and VARCHAR Types
      • 6.2.3.2 The BLOB and TEXT Types
      • 6.2.3.3 The ENUM Type
      • 6.2.3.4 The SET Type
    • 6.2.4 Choosing the Right Type for a Column
    • 6.2.5 Using Column Types from Other Database Engines
    • 6.2.6 Column Type Storage Requirements
  • 6.3 Functions for Use in SELECT and WHERE Clauses
    • 6.3.1 Non-Type-Specific Operators and Functions
      • 6.3.1.1 Parenthesis
      • 6.3.1.2 Comparison Operators
      • 6.3.1.3 Logical Operators
      • 6.3.1.4 Control Flow Functions
    • 6.3.2 String Functions
      • 6.3.2.1 String Comparison Functions
      • 6.3.2.2 Case Sensitivity
    • 6.3.3 Numeric Functions
      • 6.3.3.1 Arithmetic Operations
      • 6.3.3.2 Mathematical Functions
    • 6.3.4 Date and Time Functions
    • 6.3.5 Other Functions
      • 6.3.5.1 Bit Functions
      • 6.3.5.2 Miscellaneous Functions
  • 6.4 Data Manipulation: SELECT, INSERT, UPDATE, DELETE
    • 6.4.1 SELECT Syntax
      • 6.4.1.1 JOIN Syntax
    • 6.4.2 UNION Syntax
    • 6.4.3 INSERT Syntax
      • 6.4.3.1 INSERT ... SELECT Syntax
    • 6.4.4 INSERT DELAYED syntax
    • 6.4.5 UPDATE Syntax
    • 6.4.6 DELETE Syntax
    • 6.4.7 TRUNCATE Syntax
    • 6.4.8 REPLACE Syntax
    • 6.4.9 LOAD DATA INFILE Syntax
  • 6.5 Data Definition: CREATE, DROP, ALTER
    • 6.5.1 CREATE DATABASE Syntax
    • 6.5.2 DROP DATABASE Syntax
    • 6.5.3 CREATE TABLE Syntax
      • 6.5.3.1 Silent Column Specification Changes
    • 6.5.4 ALTER TABLE Syntax
    • 6.5.5 RENAME TABLE Syntax
    • 6.5.6 DROP TABLE Syntax
    • 6.5.7 CREATE INDEX Syntax
    • 6.5.8 DROP INDEX Syntax
  • 6.6 Basic MySQL User Utility Commands
    • 6.6.1 USE Syntax
    • 6.6.2 DESCRIBE Syntax (Get Information About Columns)
  • 6.7 MySQL Transactional and Locking Commands
    • 6.7.1 BEGIN/COMMIT/ROLLBACK Syntax
    • 6.7.2 LOCK TABLES/UNLOCK TABLES Syntax
    • 6.7.3 SET TRANSACTION Syntax
  • 6.8 HANDLER Syntax
  • 6.9 MySQL Full-text Search
    • 6.9.1 Fulltext restrictions
    • 6.9.2 Fine-tuning MySQL Full-text Search
    • 6.9.3 New Features of Full-text Search to Appear in MySQL 4.0
    • 6.9.4 Full-text Search TODO
• 7 MySQL Table Types
  • 7.1 MyISAM Tables
    • 7.1.1 Space Needed for Keys
    • 7.1.2 MyISAM Table Formats
      • 7.1.2.1 Static (Fixed-length) Table Characteristics
      • 7.1.2.2 Dynamic Table Characteristics
      • 7.1.2.3 Compressed Table Characteristics
    • 7.1.3 MyISAM table problems.
      • 7.1.3.1 Corrupted MyISAM tables.
      • 7.1.3.2 Clients is using or hasn't closed the table properly
  • 7.2 MERGE Tables
  • 7.3 ISAM Tables
  • 7.4 HEAP Tables
  • 7.5 BDB or Berkeley_DB Tables
    • 7.5.1 Overview of BDB Tables
    • 7.5.2 Installing BDB
    • 7.5.3 BDB startup options
    • 7.5.4 Some characteristic of BDB tables:
    • 7.5.5 Some things we need to fix for BDB in the near future:
    • 7.5.6 Operating systems supported by BDB
    • 7.5.7 Errors You May Get When Using BDB Tables
  • 7.6 InnoDB Tables
    • 7.6.1 InnoDB tables overview
    • 7.6.2 InnoDB startup options
    • 7.6.3 Creating InnoDB table space
      • 7.6.3.1 If something goes wrong in database creation
    • 7.6.4 Creating InnoDB tables
      • 7.6.4.1 Converting MyISAM tables to InnoDB
    • 7.6.5 Adding and removing InnoDB data and log files
    • 7.6.6 Backing up and recovering an InnoDB database
      • 7.6.6.1 Checkpoints
    • 7.6.7 Moving an InnoDB database to another machine
    • 7.6.8 InnoDB transaction model
      • 7.6.8.1 Consistent read
      • 7.6.8.2 Locking reads
      • 7.6.8.3 Next-key locking: avoiding the phantom problem
      • 7.6.8.4 Locks set by different SQL statements in InnoDB
      • 7.6.8.5 Deadlock detection and rollback
      • 7.6.8.6 An example of how the consistent read works in InnoDB
    • 7.6.9 Performance tuning tips
      • 7.6.9.1 The InnoDB Monitor
    • 7.6.10 Implementation of multiversioning
    • 7.6.11 Table and index structures
      • 7.6.11.1 Physical structure of an index
      • 7.6.11.2 Insert buffering
      • 7.6.11.3 Adaptive hash indexes
      • 7.6.11.4 Physical record structure
      • 7.6.11.5 How an auto-increment column works in InnoDB
    • 7.6.12 File space management and disk i/o
      • 7.6.12.1 Disk i/o
      • 7.6.12.2 File space management
      • 7.6.12.3 Defragmenting a table
    • 7.6.13 Error handling
    • 7.6.14 Some restrictions on InnoDB tables
    • 7.6.15 InnoDB contact information
• 8 MySQL APIs
  • 8.1 MySQL PHP API
    • 8.1.1 Common Problems with MySQL and PHP
  • 8.2 MySQL Perl API
    • 8.2.1 DBI with DBD::mysql
    • 8.2.2 The DBI Interface
    • 8.2.3 More DBI/DBD Information
  • 8.3 MySQL ODBC Support
    • 8.3.1 How To Install MyODBC
    • 8.3.2 How to Fill in the Various Fields in the ODBC Administrator Program
    • 8.3.3 Connect parameters for MyODBC
    • 8.3.4 How to Report Problems with MyODBC
    • 8.3.5 Programs Known to Work with MyODBC
    • 8.3.6 How to Get the Value of an AUTO_INCREMENT Column in ODBC
    • 8.3.7 Reporting Problems with MyODBC
  • 8.4 MySQL C API
    • 8.4.1 C API Datatypes
    • 8.4.2 C API Function Overview
    • 8.4.3 C API Function Descriptions
      • 8.4.3.1 mysql_affected_rows()
      • 8.4.3.6 mysql_close()
      • 8.4.3.10 mysql_connect()
      • 8.4.3.14 mysql_change_user()
      • 8.4.3.19 mysql_character_set_name()
      • 8.4.3.23 mysql_create_db()
      • 8.4.3.28 mysql_data_seek()
      • 8.4.3.32 mysql_debug()
      • 8.4.3.37 mysql_drop_db()
      • 8.4.3.42 mysql_dump_debug_info()
      • 8.4.3.46 mysql_eof()
      • 8.4.3.51 mysql_errno()
      • 8.4.3.55 mysql_error()
      • 8.4.3.59 mysql_escape_string()
      • 8.4.3.60 mysql_fetch_field()
      • 8.4.3.65 mysql_fetch_fields()
      • 8.4.3.70 mysql_fetch_field_direct()
      • 8.4.3.75 mysql_fetch_lengths()
      • 8.4.3.80 mysql_fetch_row()
      • 8.4.3.85 mysql_field_count()
      • 8.4.3.90 mysql_field_seek()
      • 8.4.3.94 mysql_field_tell()
      • 8.4.3.98 mysql_free_result()
      • 8.4.3.102 mysql_get_client_info()
      • 8.4.3.106 mysql_get_host_info()
      • 8.4.3.110 mysql_get_proto_info()
      • 8.4.3.114 mysql_get_server_info()
      • 8.4.3.118 mysql_info()
      • 8.4.3.122 mysql_init()
      • 8.4.3.126 mysql_insert_id()
      • 8.4.3.130 mysql_kill()
      • 8.4.3.134 mysql_list_dbs()
      • 8.4.3.138 mysql_list_fields()
      • 8.4.3.142 mysql_list_processes()
      • 8.4.3.146 mysql_list_tables()
      • 8.4.3.150 mysql_num_fields()
      • 8.4.3.155 mysql_num_rows()
      • 8.4.3.159 mysql_options()
      • 8.4.3.163 mysql_ping()
      • 8.4.3.167 mysql_query()
      • 8.4.3.171 mysql_real_connect()
      • 8.4.3.176 mysql_real_escape_string()
      • 8.4.3.181 mysql_real_query()
      • 8.4.3.185 mysql_reload()
      • 8.4.3.189 mysql_row_seek()
      • 8.4.3.193 mysql_row_tell()
      • 8.4.3.197 mysql_select_db()
      • 8.4.3.201 mysql_shutdown()
      • 8.4.3.205 mysql_stat()
      • 8.4.3.209 mysql_store_result()
      • 8.4.3.213 mysql_thread_id()
      • 8.4.3.217 mysql_use_result()
    • 8.4.4 C Threaded Function Descriptions
      • 8.4.4.1 my_init()
      • 8.4.4.4 mysql_thread_init()
      • 8.4.4.7 mysql_thread_end()
    • 8.4.5 C Embedded Server Function Descriptions
      • 8.4.5.1 mysql_server_init()
      • 8.4.5.5 mysql_server_end()
    • 8.4.6 Common questions and problems when using the C API
      • 8.4.6.1 Why Is It that After mysql_query() Returns Success, mysql_store_result() Sometimes Returns NULL?
      • 8.4.6.2 What Results Can I Get From a Query?
      • 8.4.6.3 How Can I Get the Unique ID for the Last Inserted Row?
      • 8.4.6.4 Problems Linking with the C API
    • 8.4.7 Building Client Programs
    • 8.4.8 How to Make a Threaded Client
    • 8.4.9 libmysqld, the Embedded MySQL Server Library
      • 8.4.9.1 Overview of the Embedded MySQL Server Library
      • 8.4.9.2 Compiling Programs with libmysqld
      • 8.4.9.3 Restrictions when using the Embedded MySQL Server
      • 8.4.9.4 Using option files with the embedded server
      • 8.4.9.5 Things left to do in Embedded Server (TODO)
      • 8.4.9.6 A Simple Embedded Server Example
      • 8.4.9.7 Licensing the Embedded Server
  • 8.5 MySQL C++ APIs
    • 8.5.1 Borland C++
  • 8.6 MySQL Java Connectivity (JDBC)
  • 8.7 MySQL Python APIs
  • 8.8 MySQL Tcl APIs
  • 8.9 MySQL Eiffel wrapper
• 9 Extending MySQL
  • 9.1 Adding New Functions to MySQL
    • 9.1.1 CREATE FUNCTION/DROP FUNCTION Syntax
    • 9.1.2 Adding a New User-definable Function
      • 9.1.2.1 UDF Calling Sequences
      • 9.1.2.2 Argument Processing
      • 9.1.2.3 Return Values and Error Handling
      • 9.1.2.4 Compiling and Installing User-definable Functions
    • 9.1.3 Adding a New Native Function
  • 9.2 Adding New Procedures to MySQL
    • 9.2.1 Procedure Analyse
    • 9.2.2 Writing a Procedure
  • 9.3 MySQL Internals
    • 9.3.1 MySQL Threads
    • 9.3.2 MySQL Test Suite
      • 9.3.2.1 Running the MySQL Test Suite
      • 9.3.2.2 Extending the MySQL Test Suite
      • 9.3.2.3 Reporting Bugs in the MySQL Test Suite
• A Problems and Common Errors
  • A.1 How to Determine What Is Causing Problems
  • A.2 Some Common Errors When Using MySQL
    • A.2.1 Access denied Error
    • A.2.2 MySQL server has gone away Error
    • A.2.3 Can't connect to [local] MySQL server error
    • A.2.4 Host '...' is blocked Error
    • A.2.5 Too many connections Error
    • A.2.6 Some non-transactional changed tables couldn't be rolled back Error
    • A.2.7 Out of memory Error
    • A.2.8 Packet too large Error
    • A.2.9 Communication Errors / Aborted Connection
    • A.2.10 The table is full Error
    • A.2.11 Can't create/write to file Error
    • A.2.12 Commands out of sync Error in Client
    • A.2.13 Ignoring user Error
    • A.2.14 Table 'xxx' doesn't exist Error
    • A.2.15 Can't initialize character set xxx error.
    • A.2.16 File Not Found
  • A.3 Installation Related Issues
    • A.3.1 Problems When Linking with the MySQL Client Library
    • A.3.2 How to Run MySQL As a Normal User
    • A.3.3 Problems with File Permissions
  • A.4 Administration Related Issues
    • A.4.1 What To Do If MySQL Keeps Crashing
    • A.4.2 How to Reset a Forgotten Password
    • A.4.3 How MySQL Handles a Full Disk
    • A.4.4 Where MySQL Stores Temporary Files
    • A.4.5 How to Protect or change the MySQL socket file `/tmp/mysql.sock'
    • A.4.6 Time Zone Problems
  • A.5 Query Related Issues
    • A.5.1 Case Sensitivity in Searches
    • A.5.2 Problems Using DATE Columns
    • A.5.3 Problems with NULL Values
    • A.5.4 Problems with alias
    • A.5.5 Deleting Rows from Related Tables
    • A.5.6 Solving Problems with No Matching Rows
  • A.6 Table Definition Related Issues
    • A.6.1 Problems with ALTER TABLE.
    • A.6.2 How To Change the Order of Columns in a Table
    • A.6.3 TEMPORARY TABLE problems
• B Some MySQL Users
  • B.1 General News Sites
  • B.2 Some Web Search Engines
  • B.3 Some Information Search Engines Concentrated on Some Area
  • B.4 Online Magazines
  • B.5 Web Sites that Use MySQL as a Backend
  • B.6 Some Domain/Internet/Web and Related Services
  • B.7 Web Sites that Use PHP and MySQL
  • B.8 Some MySQL Consultants
  • B.9 Programming
  • B.10 Uncategorized Pages
• C MySQL customer usage
• D Contributed Programs
  • D.1 APIs
  • D.2 Clients
  • D.3 Web Tools
  • D.4 Performance Benchmarking Tools
  • D.5 Authentication Tools
  • D.6 Converters
  • D.7 Using MySQL with Other Products
  • D.8 Useful Tools
  • D.9 RPMs for Common Tools (Most Are for RedHat 6.1)
  • D.10 Useful Functions
  • D.11 Windows programs
  • D.12 Uncategorized
• E Credits
  • E.1 Developers at MySQL AB
  • E.2 Contributors to MySQL
  • E.3 Supporters to MySQL
• F MySQL change history
  • F.1 Changes in release 4.0.x (Development; Alpha)
    • F.1.1 Changes in release 4.0.0
  • F.2 Changes in release 3.23.x (Stable)
    • F.2.1 Changes in release 3.23.44
    • F.2.2 Changes in release 3.23.43
    • F.2.3 Changes in release 3.23.42
    • F.2.4 Changes in release 3.23.41
    • F.2.5 Changes in release 3.23.40
    • F.2.6 Changes in release 3.23.39
    • F.2.7 Changes in release 3.23.38
    • F.2.8 Changes in release 3.23.37
    • F.2.9 Changes in release 3.23.36
    • F.2.10 Changes in release 3.23.35
    • F.2.11 Changes in release 3.23.34a
    • F.2.12 Changes in release 3.23.34
    • F.2.13 Changes in release 3.23.33
    • F.2.14 Changes in release 3.23.32
    • F.2.15 Changes in release 3.23.31
    • F.2.16 Changes in release 3.23.30
    • F.2.17 Changes in release 3.23.29
    • F.2.18 Changes in release 3.23.28
    • F.2.19 Changes in release 3.23.27
    • F.2.20 Changes in release 3.23.26
    • F.2.21 Changes in release 3.23.25
    • F.2.22 Changes in release 3.23.24
    • F.2.23 Changes in release 3.23.23
    • F.2.24 Changes in release 3.23.22
    • F.2.25 Changes in release 3.23.21
    • F.2.26 Changes in release 3.23.20
    • F.2.27 Changes in release 3.23.19
    • F.2.28 Changes in release 3.23.18
    • F.2.29 Changes in release 3.23.17
    • F.2.30 Changes in release 3.23.16
    • F.2.31 Changes in release 3.23.15
    • F.2.32 Changes in release 3.23.14
    • F.2.33 Changes in release 3.23.13
    • F.2.34 Changes in release 3.23.12
    • F.2.35 Changes in release 3.23.11
    • F.2.36 Changes in release 3.23.10
    • F.2.37 Changes in release 3.23.9
    • F.2.38 Changes in release 3.23.8
    • F.2.39 Changes in release 3.23.7
    • F.2.40 Changes in release 3.23.6
    • F.2.41 Changes in release 3.23.5
    • F.2.42 Changes in release 3.23.4
    • F.2.43 Changes in release 3.23.3
    • F.2.44 Changes in release 3.23.2
    • F.2.45 Changes in release 3.23.1
    • F.2.46 Changes in release 3.23.0
  • F.3 Changes in release 3.22.x (Older; Still supported)
    • F.3.1 Changes in release 3.22.35
    • F.3.2 Changes in release 3.22.34
    • F.3.3 Changes in release 3.22.33
    • F.3.4 Changes in release 3.22.32
    • F.3.5 Changes in release 3.22.31
    • F.3.6 Changes in release 3.22.30
    • F.3.7 Changes in release 3.22.29
    • F.3.8 Changes in release 3.22.28
    • F.3.9 Changes in release 3.22.27
    • F.3.10 Changes in release 3.22.26
    • F.3.11 Changes in release 3.22.25
    • F.3.12 Changes in release 3.22.24
    • F.3.13 Changes in release 3.22.23
    • F.3.14 Changes in release 3.22.22
    • F.3.15 Changes in release 3.22.21
    • F.3.16 Changes in release 3.22.20
    • F.3.17 Changes in release 3.22.19
    • F.3.18 Changes in release 3.22.18
    • F.3.19 Changes in release 3.22.17
    • F.3.20 Changes in release 3.22.16
    • F.3.21 Changes in release 3.22.15
    • F.3.22 Changes in release 3.22.14
    • F.3.23 Changes in release 3.22.13
    • F.3.24 Changes in release 3.22.12
    • F.3.25 Changes in release 3.22.11
    • F.3.26 Changes in release 3.22.10
    • F.3.27 Changes in release 3.22.9
    • F.3.28 Changes in release 3.22.8
    • F.3.29 Changes in release 3.22.7
    • F.3.30 Changes in release 3.22.6
    • F.3.31 Changes in release 3.22.5
    • F.3.32 Changes in release 3.22.4
    • F.3.33 Changes in release 3.22.3
    • F.3.34 Changes in release 3.22.2
    • F.3.35 Changes in release 3.22.1
    • F.3.36 Changes in release 3.22.0
  • F.4 Changes in release 3.21.x
    • F.4.1 Changes in release 3.21.33
    • F.4.2 Changes in release 3.21.32
    • F.4.3 Changes in release 3.21.31
    • F.4.4 Changes in release 3.21.30
    • F.4.5 Changes in release 3.21.29
    • F.4.6 Changes in release 3.21.28
    • F.4.7 Changes in release 3.21.27
    • F.4.8 Changes in release 3.21.26
    • F.4.9 Changes in release 3.21.25
    • F.4.10 Changes in release 3.21.24
    • F.4.11 Changes in release 3.21.23
    • F.4.12 Changes in release 3.21.22
    • F.4.13 Changes in release 3.21.21a
    • F.4.14 Changes in release 3.21.21
    • F.4.15 Changes in release 3.21.20
    • F.4.16 Changes in release 3.21.19
    • F.4.17 Changes in release 3.21.18
    • F.4.18 Changes in release 3.21.17
    • F.4.19 Changes in release 3.21.16
    • F.4.20 Changes in release 3.21.15
    • F.4.21 Changes in release 3.21.14b
    • F.4.22 Changes in release 3.21.14a
    • F.4.23 Changes in release 3.21.13
    • F.4.24 Changes in release 3.21.12
    • F.4.25 Changes in release 3.21.11
    • F.4.26 Changes in release 3.21.10
    • F.4.27 Changes in release 3.21.9
    • F.4.28 Changes in release 3.21.8
    • F.4.29 Changes in release 3.21.7
    • F.4.30 Changes in release 3.21.6
    • F.4.31 Changes in release 3.21.5
    • F.4.32 Changes in release 3.21.4
    • F.4.33 Changes in release 3.21.3
    • F.4.34 Changes in release 3.21.2
    • F.4.35 Changes in release 3.21.0
  • F.5 Changes in release 3.20.x
    • F.5.1 Changes in release 3.20.18
    • F.5.2 Changes in release 3.20.17
    • F.5.3 Changes in release 3.20.16
    • F.5.4 Changes in release 3.20.15
    • F.5.5 Changes in release 3.20.14
    • F.5.6 Changes in release 3.20.13
    • F.5.7 Changes in release 3.20.11
    • F.5.8 Changes in release 3.20.10
    • F.5.9 Changes in release 3.20.9
    • F.5.10 Changes in release 3.20.8
    • F.5.11 Changes in release 3.20.7
    • F.5.12 Changes in release 3.20.6
    • F.5.13 Changes in release 3.20.3
    • F.5.14 Changes in release 3.20.0
  • F.6 Changes in release 3.19.x
    • F.6.1 Changes in release 3.19.5
    • F.6.2 Changes in release 3.19.4
    • F.6.3 Changes in release 3.19.3
• G Comments on porting to other systems
  • G.1 Debugging a MySQL server
    • G.1.1 Compiling MYSQL for debugging.
    • G.1.2 Creating trace files
    • G.1.3 Debugging mysqld under gdb
    • G.1.4 Using a stack trace
    • G.1.5 Using log files to find cause of errors in mysqld
    • G.1.6 Making a test case when you experience table corruption
  • G.2 Debugging a MySQL client
  • G.3 The DBUG package.
  • G.4 Locking methods
  • G.5 Comments about RTS threads
  • G.6 Differences between different thread packages
• H Environment Variables
• I Description of MySQL regular expression syntax
• J What is Unireg?
• K GNU GENERAL PUBLIC LICENSE
  • K.1 Preamble
  • K.2 TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
  • K.3 How to Apply These Terms to Your New Programs
• L GNU LESSER GENERAL PUBLIC LICENSE
  • L.1 Preamble
  • L.2 TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
  • L.3 How to Apply These Terms to Your New Libraries
• M Pieces of the manual in transit
  • M.1 Installing a MySQL Binary Distribution
  • M.2 Perl Installation Comments
    • M.2.1 Installing Perl on Unix
    • M.2.2 Installing ActiveState Perl on Windows
    • M.2.3 Installing the MySQL Perl Distribution on Windows
    • M.2.4 Problems Using the Perl DBI/DBD Interface
  • M.3 Functions for Use with GROUP BY Clauses
• SQL command, type and function index
• Concept Index

This document was generated on 11 October 2001 using the texi2html translator version 1.52 (extended by davida@detron.se).